|
The range statement relates to the unit of competency as a whole. It allows for different work environments and situations that may affect performance. Bold italicised wording, if used in the performance criteria, is detailed below. Essential operating conditions that may be present with training and assessment (depending on the work situation, needs of the candidate, accessibility of the item, and local industry and regional contexts) may also be included. |
Ergonomic requirements may include: | avoiding radiation from computer screenschair height, seat and back adjustmentdocument holderfootrestkeyboard and mouse positionlightingnoise minimisation posturescreen positionworkstation height and layout |
Work organisation strategies may include: | exercise breaks mix of repetitive and other activitiesrest periods |
Energy and resource conservation techniques may include: | double-sided paper userecycling used and shredded paperre-using paper for rough drafts (observing confidentiality requirements)using power-save options for equipment |
Spreadsheet design may include: | analysisappropriatenessavoidance of blank rows and columns embedding cell references in formulaeformulaeformatting and reformattingfunctions headers and footersheadingsheadings and labels identification and parametersimport and export of datalabelslinked formulaemulti-page documentspivot tablesrelative and absolute cell referencessplit screen operation |
Functions may include: | basic financial functions (if available)date functionslogical functions (lookup, if, choose, true, false, conditions)mathematical functions (square root, integer, absolute value, round)simple nested functions statistical functions (standard deviation, count, maximum, minimum) |
Formulae may include: | additionaveragecomparisondivisionexponentiationmultiplicationpercentagesubtractioncombinations of above |
Macros may include: | printing sections of a spreadsheet |
Templates may include: | font types and sizesformsheaders and footersheadings page formatsreports |
Importing and exporting data may include: | proofreading reformatting split screen (if available) |
Printing may include: | charts entire workbooksselected data within a worksheetworksheets |
Naming and storing spreadsheets may include: | authorised access file naming conventionsfiling locationsorganisational policy for backing up filesorganisational policy for filing hard copies of spreadsheetssecuritystorage in folders and sub-foldersstorage on disk drives, CD-ROM, USB, tape back-up, server |
Graphs may include: | barlinepiescatterstack3D |
Creating graphs may include: | data rangekeys and legendslabels and titlesnamingsizing (if possible)using graph menuX and Y axis |